﻿CREATE TABLE [dbo].[IndexPictures]
(
	[Id] INT NOT NULL PRIMARY KEY identity, 
    [Name] NVARCHAR(50) NULL, 
    [GUID] NCHAR(36) NULL, 
    [Description] NVARCHAR(500) NULL, 
    [Sort] INT NOT NULL DEFAULT 0
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'图片名称',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'IndexPictures',
    @level2type = N'COLUMN',
    @level2name = N'Name'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'图片路径',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'IndexPictures',
    @level2type = N'COLUMN',
    @level2name = 'GUID'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'图片描述',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'IndexPictures',
    @level2type = N'COLUMN',
    @level2name = N'Description'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'排序',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'IndexPictures',
    @level2type = N'COLUMN',
    @level2name = N'Sort'